Creating a new connection

To create a new connection:

  1. Start Data Connections, then select the relevant connector, and then on the Actions list, click New Connection.
    A new connection appears beneath the relevant connector in the Connections tree.
  2. Type a name for the connection, then press Enter.
  3. Using the Properties grid, set up the following connection properties as required for each connector type:

Active Directory – Specify your LDAP data source connection properties.

ALM – Specify your Ivanti Asset Lifecycle Manager database connection properties.

eDirectory – Specify your LDAP data source connection properties.

Generic Data Source – Specify your data source connection properties for access to a database of type MS Access, MS Excel, MS SQL Server or Oracle.

If you want to use the Generic Data Source to connect to SQL Server using TLS 1.2, use SQL Server (MSOLEDBSQL). With this provider, if you receive an error saying that the MSOLEDBSQL provider is not registered on the local machine, this means that you need to install the Microsoft OLE DB Driver for SQL Server on your web server (and any machine running Console for testing the connection). You can download this driver from Download Microsoft OLE DB Driver for SQL Server.

If you are using Oracle on a 64-bit system, use Oracle64, if you are using Oracle on a 32-bit system, use Oracle.

If you are using MS Access or MS Excel, you just need to select the relevant *.mdb or *.xls file. You do not need to specify the Server.

Ivanti Neurons – This connection is for data import only, for more information, see Importing data from Ivanti Neurons.

LDAP – Specify your LDAP data source connection properties.

LDMS – Connects to the underlying Ivanti Endpoint Manager database. Specify your database connection details.

LDMS WebService – Connects to the Ivanti Endpoint Manager MBSDK web service. Specify the connection details for the web service.

  1. Click to test the connection to your database.
    If the connection fails, check your database details, then test the connection again.
  2. Click to save the new connection.

To delete or rename an existing connection, right-click the connection, then select the relevant option.

The property grid for eDirectory and LDAP connections includes a Browse Directory field. This is not a property that you need to set when creating a connection, but enables you to browse the directory tree for the connection that you have created.

Testing your connections

To test a connection:

  1. Open Data Connections window, then in the Data Connections tree, select the connection that you want to test.
  2. In the Actions list, click Test Connection.
    A confirmation box appears, confirming that the connection succeeded.

If the test does not work, you can try the following:

  • Check your connection details and correct any mistakes. Ensure that you save your changes.
  • Restart the application pool to update the metadata cache.
  • If the error is txt/XML related, then check for unsupported characters in the result set (for example, eDirectory does not support umlauts in the common name field). You will not be able to access any objects until the problem is resolved.
  • If you want to access Desktop Manager or Endpoint Manager, then you must have already installed Service Desk or Asset Manager.